create or replace
TRIGGER PIECE_RANGED_WEAPONS_TRIGGER
BEFORE INSERT ON PIECE_RANGED_WEAPONS
FOR EACH ROW WHEN (NEW.PIECE_RANGED_WEAPONS_ID IS NULL)
BEGIN 
	SELECT PIECE_RANGED_WEAPONS_SEQ.NEXTVAL 
	INTO :NEW.PIECE_RANGED_WEAPONS_ID 
	FROM DUAL;
END;